課程資訊
課程名稱
資料庫系統-從SQL到NoSQL
Database Management System – from SQL to NoSQL 
開課學期
107-1 
授課對象
電機資訊學院  電機工程學研究所  
授課教師
駱明凌 
課號
EE5178 
課程識別碼
921 U2560 
班次
 
學分
3.0 
全/半年
半年 
必/選修
選修 
上課時間
星期二7,8,9(14:20~17:20) 
上課地點
電二145 
備註
總人數上限:80人 
Ceiba 課程網頁
http://ceiba.ntu.edu.tw/1071EE5178_DBMS 
課程簡介影片
 
核心能力關聯
本課程尚未建立核心能力關連
課程大綱
為確保您我的權利,請尊重智慧財產權及不得非法影印
課程概述

Database processing and database management systems (DBMS) have been a corner stone of modern society. In science, engineering, business and enterprise alike, data play a central role in their progress. With recent developments in the fields of big data, machine learning, social network, cloud computing and Internet of Things, to name a few, increases in data volume and manifestations of new data patterns have made the study of database both more interesting and more challenging. In this course, we cover the theory and practice of database management systems. We discuss the modeling, programming, management, architecture and implementation aspects of DBMS, study the evolution from well-established relational SQL databases to the new NoSQL databases, and cover the newest trends in database research brought about by the challenges of the big data trends.
 

課程目標
1. Acquire basic knowledge and concepts about databases and database management systems (DBMS)
2. Obtain basic capabilities of programming for databases, and basic capabilities of operating a DBMS
3. Learn the design thinking and rationales behind various database technologies -- hope one day to use these design reasoning skills in real-life designs
4. Learn the design thinking and rationales for large (often distributed) software systems  
課程要求
Understanding of programming languages, capability to use a programming language (at least one of C/C++, Java. Python programming is a plus.)
Understanding of basic data structures (Lists, trees, hash tables, etc.)
Familiarity in the use of computer (PC)
Ability to search for and utilize resources online  
預期每週課後學習時數
 
Office Hours
 
指定閱讀
NULL 
參考書目
Fundamentals of Database Systems (7th Edition)
by Ramez Elmasri (Author),‎ Shamkant B. Navathe (Author)
Database Management Systems, 3rd Edition
by Raghu Ramakrishnan (Author),‎ Johannes Gehrke (Author) 
評量方式
(僅供參考)
 
No.
項目
百分比
說明
1. 
Homework 
50% 
作業 
2. 
Mid term exam 
20% 
期中考 
3. 
Final project  
25% 
期末專題研究及報告 
4. 
Class Participation 
5% 
課堂參與 
 
課程進度
週次
日期
單元主題
第1週
9/11  Introduction 
第2週
9/18  Conceptual modeling - the Entity-Relationship model 
第3週
9/25  Relational database model - concepts and constraints 
第4週
10/02  Basic SQL 
第5週
10/09  Relational algebra and advanced SQL 
第6週
10/16  RDB design and normalization 
第7週
10/23  Data models - Object-oriented databases and XML-databases 
第8週
10/30  Database interface to programming languages;
Transaction processing concepts 
第9週
11/06  Physical database design - storage, indexing, transaction processing and concurrency control techniques 
第10週
11/13  Query processing and query optimization concepts;
Basic distributed database concepts 
第11週
11/20  Advanced database topics I - Data analytics, OLAP, data warehouses and data lakes;
big data trend and related topics 
第12週
11/27  Mid term exam 
第13週
12/04  Advanced database topics II - Big data trend, related topic and new DB workloads 
第14週
12/11  Advanced database topics III - NoSQL data models and systems
 
第15週
12/18  Advanced database topics IV - Database-as-a-service and other advanced topics 
第16週
12/25  Final project presentation I 
第17週
1/01  National holiday 
第18週
1/08  Final project presentation II